CREATE TABLE [dbo].[FS_Student]
(
[fdStudNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSchoolPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdSchoolPlace] DEFAULT ('南校区'),
[fdStudName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudSchoolID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudSchoolID] DEFAULT (''),
[fdStudSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudSchool] DEFAULT (''),
[fdStudCollegeID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudCollegeID] DEFAULT (''),
[fdStudCollege] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudCollege] DEFAULT (''),
[fdStudSpecID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudClass] DEFAULT (''),
[fdStudSpec] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudSpec] DEFAULT (''),
[fdStudHomeTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudHomeTel] DEFAULT (''),
[fdStudPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudPhone] DEFAULT (''),
[fdStudAddress] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudAddress] DEFAULT (''),
[fdStudPost] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudPost] DEFAULT (''),
[fdHealth] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdHealth] DEFAULT (''),
[fdSex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdSex] DEFAULT (''),
[fdSexID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdSexID] DEFAULT (''),
[fdPolitics] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdPolitics] DEFAULT (''),
[fdPoliticsID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdPoliticsID] DEFAULT (''),
[fdLongevity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdLongevity] DEFAULT (''),
[fdLongevityID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdLongevityID] DEFAULT (''),
[fdTrainID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdTrainID] DEFAULT (''),
[fdTrain] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdTrain] DEFAULT (''),
[fdNationID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdNationID] DEFAULT (''),
[fdNation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdNation] DEFAULT (''),
[fdPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdPlace] DEFAULT (''),
[fdPlaceID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdPlaceID] DEFAULT (''),
[fdStudYearInt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudYearOut] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudMethod] [int] NOT NULL,
[fdStudSelfCon] [bit] NOT NULL CONSTRAINT [DF_FS_Student_fdStudSelfCon] DEFAULT ((0)),
[fdStudCollCon] [bit] NOT NULL CONSTRAINT [DF_FS_Student_fdStudCollCon] DEFAULT ((0)),
[fdStudAdmiCon] [bit] NOT NULL CONSTRAINT [DF_FS_Student_fdStudAdmiCon] DEFAULT ((0)),
[fdStudBarCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudBarCode] DEFAULT (''),
[fdStudLoginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudLoginIP] DEFAULT (''),
[fdStudLoginAt] [datetime] NULL,
[fdStudIDCard] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudIDCard] DEFAULT (''),
[fdStudTrainUnit] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudTrainUnit] DEFAULT (''),
[fdStudNote] [text] COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Student_fdStudNote] DEFAULT (''),
[fdStudType] [int] NOT NULL CONSTRAINT [DF_FS_Student_fdStudType] DEFAULT ((1)),
[fdEmplyStatus] [int] NOT NULL CONSTRAINT [DF_FS_Student_fdEmplyStatus] DEFAULT ((0)),
[fdYear] [int] NOT NULL CONSTRAINT [DF_FS_Student_fdYear] DEFAULT ((2006)),
[fdGo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__FS_Student__fdGo__4B622666] DEFAULT ('未就业')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Student] ADD CONSTRAINT [PK_FS_Student] PRIMARY KEY CLUSTERED  ([fdStudNo]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'健康状况', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdHealth'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学历', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdLongevity'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学历代码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdLongevityID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'民族', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdNation'
GO
EXEC sp_addextendedproperty N'MS_Description', N'民族代码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdNationID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'生源地', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdPlace'
GO
EXEC sp_addextendedproperty N'MS_Description', N'生源地代号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdPlaceID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'政治面貌代号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdPolitics'
GO
EXEC sp_addextendedproperty N'MS_Description', N'政治面貌代号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdPoliticsID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'性别', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdSex'
GO
EXEC sp_addextendedproperty N'MS_Description', N'性别代号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdSexID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'家庭通信地址', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudAddress'
GO
EXEC sp_addextendedproperty N'MS_Description', N'就业指导中心确认', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudAdmiCon'
GO
EXEC sp_addextendedproperty N'MS_Description', N'条形码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudBarCode'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学院确认', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudCollCon'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学院', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudCollege'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学院编号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudCollegeID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'身份证号码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudIDCard'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登陆时间（null表示未登陆，首次登陆要求更改密码）', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudLoginAt'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登陆IP', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudLoginIP'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学年制', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudMethod'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学生姓名', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学号（登陆帐号）', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudNo'
GO
EXEC sp_addextendedproperty N'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudNote'
GO
EXEC sp_addextendedproperty N'MS_Description', N'电话', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudPhone'
GO
EXEC sp_addextendedproperty N'MS_Description', N'邮政编码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudPost'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登陆密码（初始化与学号相同）', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudPwd'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学校', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudSchool'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学校代码', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudSchoolID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'个人确认', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudSelfCon'
GO
EXEC sp_addextendedproperty N'MS_Description', N'专业', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudSpec'
GO
EXEC sp_addextendedproperty N'MS_Description', N'专业编号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudSpecID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'定向委培单位', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudTrainUnit'
GO
EXEC sp_addextendedproperty N'MS_Description', N'1本科生 2 研究生', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudType'
GO
EXEC sp_addextendedproperty N'MS_Description', N'入学时间', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudYearInt'
GO
EXEC sp_addextendedproperty N'MS_Description', N'毕业时间', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdStudYearOut'
GO
EXEC sp_addextendedproperty N'MS_Description', N'培养方式', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdTrain'
GO
EXEC sp_addextendedproperty N'MS_Description', N'培养方式代号', 'SCHEMA', N'dbo', 'TABLE', N'FS_Student', 'COLUMN', N'fdTrainID'
GO
